﻿<%@ Page Language="VB" AutoEventWireup="false" MasterPageFile="~/Welcome.master"
CodeFile="Default.aspx.vb" Inherits="_Default" Title="CIMS" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <div>
        
        <table border="0" cellpadding="0" cellspacing="0" style="width: 800px; height: 500px">
        <tr>
            <td style="height: 150px; width: 200px;">
                <asp:Label ID="Label4" runat="server" Text="Welcome to CIMS" Font-Bold="True" 
                Font-Names="Verdana" Font-Size="Medium" ForeColor="#404040" Width="200px" Height="23px" />
                <asp:Label ID="User_lbl" runat="server" Font-Bold="False" 
                Font-Names="Verdana" Font-Size="X-Small" ForeColor="#0C58A2" Width="200px" />
                <br />
                <asp:Label ID="Today_lbl" runat="server" Text="Today is Mar 3, 2008" Font-Bold="True" 
                Font-Names="Verdana" Font-Size="Smaller" ForeColor="#404040" Width="200px" />
            </td>
            <td style="height: 150px; width: 600px;" valign="top">
                <asp:Panel ID="Panel3" runat="server" Height="150px" Width="600px" BorderColor="Black" 
                    BorderStyle="Solid" BorderWidth="1px" ScrollBars="Vertical">
                <asp:Label ID="Label3" runat="server" Text="Birthday Reminder" BackColor="#0C58A2" 
                    Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="White" 
                    Height="17px" Width="580px" BorderStyle="None" />
                <div style="text-align: left; font-family: Verdana; font-size:smaller;">
                    &nbsp; No. of Days : 
                    <asp:TextBox ID="txtBday" runat="server" MaxLength="2" Width="24px">30</asp:TextBox>
                    <asp:Button ID="btnBDay" runat="server" Text="Go" Width="32px" />
                    <cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" runat="server" FilterType="Numbers" TargetControlID="txtBday">
                    </cc1:FilteredTextBoxExtender>
                </div>
                <asp:DataGrid ID="Bday_dg" runat="server" AllowSorting="True"
                            AutoGenerateColumns="False" BackColor="White" BorderColor="Black" BorderStyle="None"
                            BorderWidth="1px" CellPadding="1" Font-Names="Verdana" Font-Size="10pt"
                            TabIndex="12" Width="580px" PageSize="5">
                            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                            <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                            <PagerStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Left" Mode="NumericPages"
                                PageButtonCount="9" Position="Top" />
                            <AlternatingItemStyle BackColor="White" />
                            <ItemStyle BackColor="#F2F3F5" ForeColor="Black" />
                            <HeaderStyle BackColor="White" Font-Bold="True" ForeColor="#0C58A2" />
                            <Columns>
                                <asp:BoundColumn DataField="ClientName" HeaderText="Client Name">
                                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Left" />
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="birthday" HeaderText="Birth Date" DataFormatString="{0:dd-MMM-yyyy}">
                                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Right" />
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="Age" HeaderText="Age" DataFormatString="{0:#,##0}">
                                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Right" />
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="advisor" HeaderText="Advisor">
                                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Center" />
                                </asp:BoundColumn>
                            </Columns>
                        </asp:DataGrid>
                <asp:Label ID="Bday_lbl2" runat="server" BackColor="White" 
                    Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                    Height="58px" Width="580px" Font-Italic="True" Visible="False" />
                <asp:Label ID="Bday_lbl" runat="server" Text="No records to display" BackColor="White" 
                    Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                    Height="75px" Width="580px" Font-Italic="True" Visible="False" />
                </asp:Panel>            
            </td>
        </tr>
        <tr>
            <td colspan="2" style="height: 150px" valign="top">
                <asp:Panel ID="Panel1" runat="server" Height="150px" Width="800px" BorderColor="Black" 
                    BorderStyle="Solid" BorderWidth="1px" ScrollBars="Vertical">
                    <asp:Label ID="Label1" runat="server" Text="Due Contributions" BackColor="#0C58A2" 
                        Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="White" 
                        Height="17px" Width="780px" BorderStyle="None" />
                    <div style="text-align: left; font-family: Verdana; font-size:smaller;">
                        &nbsp; No. of Days : 
                        <asp:TextBox ID="txtDue" runat="server" MaxLength="2" Width="24px">30</asp:TextBox>
                        <asp:Button ID="btnhDue" runat="server" Text="Go" Width="32px" />
                        <cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender2" runat="server" FilterType="Numbers" TargetControlID="txtDue">
                        </cc1:FilteredTextBoxExtender>
                    </div>
                    <asp:DataGrid ID="Due_dg" runat="server" AllowSorting="True"
                        AutoGenerateColumns="False" BackColor="White" BorderColor="Black" BorderStyle="None"
                        BorderWidth="1px" CellPadding="1" Font-Names="Verdana" Font-Size="10pt"
                        TabIndex="12" Width="780px" PageSize="5">
                        <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                        <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                        <PagerStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Left" Mode="NumericPages"
                            PageButtonCount="9" Position="Top" />
                        <AlternatingItemStyle BackColor="White" />
                        <ItemStyle BackColor="#F2F3F5" ForeColor="Black" />
                        <HeaderStyle BackColor="White" Font-Bold="True" ForeColor="#0C58A2" />
                        <Columns>
                            <asp:BoundColumn DataField="Client_Name" HeaderText="Client Name">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Left" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="contribution_amt" HeaderText="Amount" DataFormatString="{0:N}">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Right" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="policy_due_dt" HeaderText="Due Date" DataFormatString="{0:dd-MMM-yyyy}">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Right" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="prdt_desc" HeaderText="Product">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Center" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="Advisor" HeaderText="Advisor">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Center" />
                            </asp:BoundColumn>
                        </Columns>
                    </asp:DataGrid>
                    <asp:Label ID="Due_lbl2" runat="server" BackColor="White" 
                        Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                        Height="58px" Width="780px" Font-Italic="True" Visible="False" />
                    <asp:Label ID="Due_lbl" runat="server" Text="No records to display" BackColor="White" 
                        Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                        Height="75px" Width="780px" Font-Italic="True" Visible="False" />
                 </asp:Panel>
            </td>
        </tr>
        <tr>
            <td colspan="2" style="height: 150px" valign="top">
                <asp:Panel ID="Panel2" runat="server" Height="150px" Width="800px" BorderColor="Black" 
                    BorderStyle="Solid" BorderWidth="1px" ScrollBars="Vertical">
                <asp:Label ID="Label2" runat="server" Text="Delayed Contributions" BackColor="#0C58A2" 
                    Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="White" 
                    Height="17px" Width="780px" BorderStyle="None" />&nbsp;

                    <asp:DataGrid ID="Delayed_dg" runat="server" AllowSorting="True"
                            AutoGenerateColumns="False" BackColor="White" BorderColor="Black" BorderStyle="None"
                            BorderWidth="1px" CellPadding="1" Font-Names="Verdana" Font-Size="10pt"
                            TabIndex="12" Width="780px" PageSize="5">
                        <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                        <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                        <PagerStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Left" Mode="NumericPages"
                                PageButtonCount="9" Position="Top" />
                        <AlternatingItemStyle BackColor="White" />
                        <ItemStyle BackColor="#F2F3F5" ForeColor="Maroon" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
                        <HeaderStyle BackColor="White" Font-Bold="True" ForeColor="#0C58A2" />
                        <Columns>
                            <asp:BoundColumn DataField="Client_Name" HeaderText="Client Name">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Left" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="contribution_amt" HeaderText="Amount" DataFormatString="{0:N}">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Right" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="policy_due_dt" HeaderText="Due Date" DataFormatString="{0:dd-MMM-yyyy}">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Right" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="prdt_desc" HeaderText="Product">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Center" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="Advisor" HeaderText="Advisor">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                        Font-Underline="False" HorizontalAlign="Center" />
                            </asp:BoundColumn>
                        </Columns>
                    </asp:DataGrid>
                <asp:Label ID="Delayed_lbl2" runat="server" BackColor="White" 
                    Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                    Height="58px" Width="780px" Font-Italic="True" Visible="False" />
                <asp:Label ID="Delayed_lbl" runat="server" Text="No records to display" BackColor="White" 
                    Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                    Height="75px" Width="780px" Font-Italic="True" Visible="False" />
                 </asp:Panel>            
            </td>
        </tr>
        <tr>
            <td colspan="2" style="height: 150px" valign="top">
                <asp:Panel ID="Panel4" runat="server" Height="150px" Width="800px" BorderColor="Black" 
                    BorderStyle="Solid" BorderWidth="1px" ScrollBars="Vertical">
                    <asp:Label ID="Label5" runat="server" Text="Maturing Policies" BackColor="#0C58A2" 
                        Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="White" 
                        Height="17px" Width="780px" BorderStyle="None" />
                    <div style="text-align: left; font-family: Verdana; font-size:smaller;">
                        &nbsp; No. of Days : 
                        <asp:TextBox ID="txtMaturity" runat="server" MaxLength="2" Width="24px">30</asp:TextBox>
                        <asp:Button ID="btnMaturity" runat="server" Text="Go" Width="32px" />
                        <cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender3" runat="server" FilterType="Numbers" TargetControlID="txtDue">
                        </cc1:FilteredTextBoxExtender>
                    </div>
                    <asp:DataGrid ID="Maturity_dg" runat="server" AllowSorting="True"
                        AutoGenerateColumns="False" BackColor="White" BorderColor="Black" BorderStyle="None"
                        BorderWidth="1px" CellPadding="1" Font-Names="Verdana" Font-Size="10pt"
                        TabIndex="12" Width="780px" PageSize="5">
                        <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                        <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                        <PagerStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Left" Mode="NumericPages"
                            PageButtonCount="9" Position="Top" />
                        <AlternatingItemStyle BackColor="White" />
                        <ItemStyle BackColor="#F2F3F5" ForeColor="Black" />
                        <HeaderStyle BackColor="White" Font-Bold="True" ForeColor="#0C58A2" />
                        <Columns>
                            <asp:BoundColumn DataField="name" HeaderText="Client Name">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Left" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="policy_no" HeaderText="Policy No">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Left" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="maturity_dt" HeaderText="Maturity Date" DataFormatString="{0:dd-MMM-yyyy}">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Right" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="prdt_desc" HeaderText="Product">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Center" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="Advisor_Name" HeaderText="Advisor">
                                <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Center" />
                            </asp:BoundColumn>
                        </Columns>
                    </asp:DataGrid>
                    <asp:Label ID="Maturity_lbl2" runat="server" BackColor="White" 
                        Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                        Height="58px" Width="780px" Font-Italic="True" Visible="False" />
                    <asp:Label ID="Maturity_lbl" runat="server" Text="No records to display" BackColor="White" 
                        Font-Bold="True" Font-Names="Verdana" Font-Size="Smaller" ForeColor="DimGray" 
                        Height="75px" Width="780px" Font-Italic="True" Visible="False" />
                 </asp:Panel>
            </td>
        </tr>
        </table>
        
        </div>
</asp:Content>